package com.gis.entity;

import lombok.Data;
import java.io.Serializable;
import java.sql.Timestamp;
import com.baomidou.mybatisplus.annotation.TableName;

/*
CREATE TABLE layer_table (
    id                  SERIAL PRIMARY KEY,             -- 自增主键


    year                INT,
    month               INT,
    day                 INT,
    time                TIMESTAMP,

    resolution           VARCHAR(100),                  -- 精度
    satellite           VARCHAR(100),                  -- 卫星
    data_level          VARCHAR(100),                  -- 数据级别
    sensor              VARCHAR(100),                  -- 传感器
    variable_name      VARCHAR(100),                  -- 变量名

    origin_name          VARCHAR(100),                  -- 原始文件名
    saved_name           VARCHAR(100),                  -- 保存文件名
    saved_dir            VARCHAR(100),                  -- 保存路径
    file_type           VARCHAR(100),
    is_published         BOOLEAN DEFAULT FALSE,          -- 是否发布

    insert_time         TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_time        TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

COMMENT ON COLUMN layer_table.id IS '自增ID';
COMMENT ON COLUMN layer_table.year IS '年份';
COMMENT ON COLUMN layer_table.month IS '月份';
COMMENT ON COLUMN layer_table.day IS '日期';
COMMENT ON COLUMN layer_table.time IS '时间';

COMMENT ON COLUMN layer_table.resolution IS '分辨率';
COMMENT ON COLUMN layer_table.satellite IS '卫星';
COMMENT ON COLUMN layer_table.data_level IS '数据级别';
COMMENT ON COLUMN layer_table.sensor IS '传感器';
COMMENT ON COLUMN layer_table.insert_time IS '插入时间';
COMMENT ON COLUMN layer_table.updated_time IS '更新时间';

COMMENT ON COLUMN layer_table.originName IS '原始文件名';
COMMENT ON COLUMN layer_table.savedName IS '保存文件名';
COMMENT ON COLUMN layer_table.savedDir IS '保存路径';
COMMENT ON COLUMN layer_table.file_type IS '文件类型';



);

COMMENT ON COLUMN layer_table.id IS '自增ID';
COMMENT ON COLUMN layer_table.year IS '年份';
COMMENT ON COLUMN layer_table.month IS '月份';
COMMENT ON COLUMN layer_table.day IS '日期';
COMMENT ON COLUMN layer_table.time IS '时间';
COMMENT ON COLUMN layer_table.type_name IS '类型';
COMMENT ON COLUMN layer_table.pricision IS '分辨率';
COMMENT ON COLUMN layer_table.satellite IS '卫星';
COMMENT ON COLUMN layer_table.data_level IS '数据级别';
COMMENT ON COLUMN layer_table.sensor IS '传感器';
COMMENT ON COLUMN layer_table.insert_time IS '插入时间';
COMMENT ON COLUMN layer_table.updated_time IS '更新时间';
*/

@Data
@TableName("layer_table")
public class LayerData implements Serializable{

    private Integer id; // 自增主键
    private Integer year; // 年份
    private Integer month; // 月份
    private Integer day; // 日期
    private String resolution; // 分辨率
    private String satellite; // 卫星
    private String dataLevel; // 数据级别
    private String sensor; // 传感器
    private Timestamp time; // 时间
    
    private String originName; // 原始文件名
    private String savedName; // 保存文件名
    private String savedDir; // 保存路径
    private String fileType; // 文件类型
    private String variableName; // 变量名
    private String style;
    private Boolean isPublished; // 是否发布

    private Float minX; // 最小经度
    private Float minY; // 最小纬度
    private Float maxX; // 最大经度
    private Float maxY; // 最大纬度
    

    private Timestamp insertTime; // 插入时间
    private Timestamp updatedTime; // 更新时间

}
